package com.shop.storage.mapper;

import java.util.List;
import com.shop.storage.domain.WmsPurchaseRequire;
import com.shop.storage.vo.response.Requirement;
import org.apache.ibatis.annotations.Param;

/**
 * 采购清单Mapper接口
 * 
 * @author shop
 * @date 2024-06-24
 */
public interface WmsPurchaseRequireMapper 
{
    /**
     * 查询采购清单
     * 
     * @param requireId 采购清单主键
     * @return 采购清单
     */
    public WmsPurchaseRequire selectWmsPurchaseRequireByRequireId(Long requireId);

    /**
     * 查询采购清单列表
     * 
     * @param wmsPurchaseRequire 采购清单
     * @return 采购清单集合
     */
    public List<WmsPurchaseRequire> selectWmsPurchaseRequireList(WmsPurchaseRequire wmsPurchaseRequire);

    /**
     * 新增采购清单
     *
     * @param wmsPurchaseRequire 采购清单
     * @return 结果
     */
    public int insertWmsPurchaseRequire(WmsPurchaseRequire wmsPurchaseRequire);

    /**
     * 修改采购清单
     * 
     * @param wmsPurchaseRequire 采购清单
     * @return 结果
     */
    public int updateWmsPurchaseRequire(WmsPurchaseRequire wmsPurchaseRequire);

    /**
     * 删除采购清单
     * 
     * @param requireId 采购清单主键
     * @return 结果
     */
    public int deleteWmsPurchaseRequireByRequireId(Long requireId);

    /**
     * 批量删除采购清单
     * 
     * @param requireIds 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteWmsPurchaseRequireByRequireIds(Long[] requireIds);

    /**
     * 组合查询
     */
    public List<Requirement> selectWmsPurchaseRequireLists(@Param("skuIds")List<Integer> skuIds, @Param("skuName") String skuName);

    /**
     * 批量添加
     * @param wareSkuIds
     * @return
     */
    public int insertWmsPurchaseRequires(@Param("wareSkuIds") Long[] wareSkuIds);

    /**
     * 根据库存id修改状态
     * @param id
     * @param status
     */
    public int updateWmsPurchaseRequireWareSkuId(@Param("ids")List<Long> id, @Param("status") Long status);

}
